package com.ruoyi.welcome.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface YyySysUserRoleMapper {

    // 查询医生人数（role_id = 102）
    @Select("SELECT COUNT(*) AS doctor_count FROM sys_user_role WHERE role_id = 102")
    int countDoctorByRoleId();

    // 查询用户人数（role_id = 101）
    @Select("SELECT COUNT(*) AS user_count FROM sys_user_role WHERE role_id = 101")
    int countUserByRoleId();
}